Release 10.1A: OpenEdge Development:
AppBuilder

Table mode

In this mode, the Query Builder allows you to specify the tables you want in the query. When you modify a query from the property sheet of a frame or browse, the Query Builder also initializes to this mode. Figure 4–5 shows how the Query Builder appears in Table mode.

Figure 4–5: Query Builder in Table mode

To select a database table, select the table name in the Available Tables list and choose the Add button; you can also double-click on the name.

To remove a table from the Selected Tables & Joins list, select the table name and choose the Remove button; you can also double-click on the name.

After you select the tables you want, the AppBuilder displays the query in the Query panel. For example, if you choose the Customer, Order, and Order-Line tables, the Query field appears, as shown in Figure 4–6.

Figure 4–6: Sample query for OF-joinable tables

As you select tables, the AppBuilder establishes the relationship among them and the other tables that you have selected. If two tables share a common key with the same name and data type, they are OF joinable. If they are not OF joinable, you must establish how they will be joined. For example, if you choose the Customer and Local-Default tables, the AppBuilder displays the query in the Query panel, as shown in Figure 4–7.

FOR EACH sports.Customer NO-LOCK, EACH sports.Local-Default WHERE TRUE /* Join to Customer incomplete */ NO-LOCK:

Figure 4–7: Query sample with incomplete join criteria

The comment indicates that you must complete the relationship of the Local-Default table to the Customer table. Complete the join criteria by choosing the Join button to enter Join mode.

If you select three or more tables and AppBuilder can establish the relationship among them, the AppBuilder still allows you to choose a table and change its join criteria. You do this by selecting the table in the Selected Tables & Joins list and choosing the Switch Join Partners button.